package com.china08.yxyapi.entity.db.questionbank.audit;

import java.util.Date;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Table;

import com.china08.yxyapi.entity.BaseEntity;

/**
 * 
 * 
 * 题库: 试题信息
 *
 */
@SuppressWarnings("serial")
@Entity
@Table(name = "yxy_quesbank_question_doc", catalog = "yxy_question_bank")
public class YxyQuesbankQuestions extends BaseEntity {

	@Column(unique = true, nullable = false, columnDefinition = "varchar(32) comment '文档计算的md5值,避免重复上传' ")
	private String md5;

	@Column(nullable = false, columnDefinition = "varchar(32) comment '文档名称' ")
	private String docName;

	@Column(nullable = false, columnDefinition = "varchar(32) comment '上传人' ")
	private String loader;

	@Column(nullable = false, columnDefinition = "datetime comment '上传时间' ")
	private Date loadDate;

	@Column(nullable = false, columnDefinition = "int comment '试题数量' ")
	private Integer quesCount;

	@Column(nullable = false, columnDefinition = "int default 0 comment '审核状态: 0:未开始,1-校对中,2-已完成' ")
	private Integer auditStatus = 0;

	@Column(columnDefinition = "varchar(32) comment '审核人id' ")
	private String auditUserId;

	@Column(columnDefinition = "varchar(32) comment '审核人名称' ")
	private String auditUserName;

	@Column(columnDefinition = "varchar(10) comment '学段：1，小学；2，初中；3，高中' ")
	private String stage;

	@Column
	private String stageName;

	@Column(columnDefinition = "varchar(10) comment '科目：2，语文；3，数学；4，英语；5，科学；6，物理；7，化学；8，历史；9，政治思品；10，地理；11，生物；20，历史与社会' ")
	private String subject;

}
